



CREATE TABLE [dbo].[SJZC_SJKXX] (
[sjkdm] varchar(64) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[sjkmc] varchar(64) COLLATE Chinese_PRC_CI_AS NULL ,
[sjklx] varchar(128) COLLATE Chinese_PRC_CI_AS NULL ,
[sjkdz] varchar(64) COLLATE Chinese_PRC_CI_AS NULL ,
[yhm] varchar(64) COLLATE Chinese_PRC_CI_AS NULL ,
[mm] varchar(64) COLLATE Chinese_PRC_CI_AS NULL ,
[ms] varchar(256) COLLATE Chinese_PRC_CI_AS NULL ,
[gxsj]  datetime NULL  ,
[cjsj]  datetime NULL  ,
CONSTRAINT [PK_SJZC_SJKXX] PRIMARY KEY ([sjkdm])
)
ON [PRIMARY]
GO


CREATE TABLE [dbo].[SJZC_SJJYWXX] (
[SJJDM] varchar(64) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[SJJMC] varchar(128) COLLATE Chinese_PRC_CI_AS NULL ,
[JLS] int NULL ,
[BRL] int NULL ,
[GXSJ] datetime NULL ,
[CJSJ] datetime NULL ,
CONSTRAINT [PK__SJZC_SJJ__A74D69F222427747] PRIMARY KEY ([SJJDM])
)
ON [PRIMARY]
GO

CREATE TABLE [dbo].[PSMS_SJJFL] (
[SJJFLDM] varchar(64) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[SJJFLMC] varchar(128) COLLATE Chinese_PRC_CI_AS NULL ,
[YJLBDM] varchar(64) COLLATE Chinese_PRC_CI_AS NULL ,
[YJLBMC] varchar(128) COLLATE Chinese_PRC_CI_AS NULL ,
[EJLBDM] varchar(64) COLLATE Chinese_PRC_CI_AS NULL ,
[EJLBMC] varchar(128) COLLATE Chinese_PRC_CI_AS NULL ,
[FLJB] varchar(2) COLLATE Chinese_PRC_CI_AS NULL ,
[JLZT] varchar(1) COLLATE Chinese_PRC_CI_AS NULL ,
[FLSM] varchar(500) COLLATE Chinese_PRC_CI_AS NULL ,
CONSTRAINT [PK_PSMS_SJJFL] PRIMARY KEY ([SJJFLDM])
)
ON [PRIMARY]
GO



CREATE TABLE [dbo].[PSMS_SJJXX] (
[SJJDM] varchar(64) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[SJJMC] varchar(128) COLLATE Chinese_PRC_CI_AS NULL ,
[SJJFLDM] varchar(64) COLLATE Chinese_PRC_CI_AS NULL ,
[SJKBM] varchar(64) COLLATE Chinese_PRC_CI_AS NULL ,
[BBLX] varchar(50) COLLATE Chinese_PRC_CI_AS NULL ,
[BBH] varchar(64) COLLATE Chinese_PRC_CI_AS NULL ,
[ZY] varchar(128) COLLATE Chinese_PRC_CI_AS NULL ,
[FBRQ] datetime NULL ,
[GXSJ] datetime NULL ,
[JLZT] varchar(1) COLLATE Chinese_PRC_CI_AS NULL ,
[BZLY] varchar(2) COLLATE Chinese_PRC_CI_AS NULL ,
CONSTRAINT [PK_PSMS_SJJXX] PRIMARY KEY ([SJJDM])
)
ON [PRIMARY]
GO


CREATE TABLE [dbo].[PSMS_SJYXX] (
[SJYDM] varchar(64) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[SJYMC] varchar(128) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[SJYBSF] varchar(64) COLLATE Chinese_PRC_CI_AS NULL ,
[SJKZDM] varchar(50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[SJYDY] varchar(4000) COLLATE Chinese_PRC_CI_AS NULL ,
[SJYLX] varchar(64) COLLATE Chinese_PRC_CI_AS NULL ,
[BSGS] varchar(64) COLLATE Chinese_PRC_CI_AS NULL ,
[SQLLX] varchar(64) COLLATE Chinese_PRC_CI_AS NULL ,
[ORALX] varchar(64) COLLATE Chinese_PRC_CI_AS NULL ,
[ZDCD] varchar(20) COLLATE Chinese_PRC_CI_AS NULL ,
[SJYYXZ] varchar(64) COLLATE Chinese_PRC_CI_AS NULL ,
[BZLY] varchar(2) COLLATE Chinese_PRC_CI_AS NULL ,
[ZHGXRQ] datetime NULL ,
[JLZT] varchar(1) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[BZ] varchar(4000) COLLATE Chinese_PRC_CI_AS NULL ,
CONSTRAINT [PK_PSMS_SJYXX] PRIMARY KEY ([SJYDM])
)
ON [PRIMARY]
GO



CREATE TABLE [dbo].[PSMS_SJYML] (
[SJJDM] varchar(64) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[SJYDM] varchar(64) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[SFZJ] varchar(1) COLLATE Chinese_PRC_CI_AS NULL ,
[SFWK] varchar(1) COLLATE Chinese_PRC_CI_AS NULL ,
[MRZ] varchar(128) COLLATE Chinese_PRC_CI_AS NULL ,
CONSTRAINT [PK_PSMS_SJYML] PRIMARY KEY ([SJJDM], [SJYDM])
)
ON [PRIMARY]
GO